package com.ynyyrj.school.mapper;

import com.ynyyrj.school.pojo.MajorList;
import com.ynyyrj.school.pojo.SchoolList;
import com.ynyyrj.school.pojo.StudentList;
import com.ynyyrj.school.pojo.school;
import org.apache.ibatis.annotations.Mapper;
import org.springframework.stereotype.Repository;

import java.util.Collection;
import java.util.List;

@Mapper
@Repository
public interface SchMapper {
    Collection<SchoolList> GetSchoolList();
     int addSchool(school school);
    int delSchool(String name);
    int updaSchool(school school);
     List<String> GetName();
    List<Integer> GetAid();
    String selectName(int aid);
     int selectId(String name);
     Collection<MajorList> GetMajorList(String name);
    Collection<StudentList> GetStudentList(String name1,String name2);
}
